UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IgPFARv6+8rhl0az5IaWiC4ODuPt0cjHPdlU4S9G+/U='
WHERE
key_id = 'bebac906561b16557fbc492744060a20f3040e357145aeb49264e80edc9efbe8'
AND (
token = 'IgPFARv6+8rhl0az5IaWiC4ODuPt0cjHPdlU4S9G+/U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)