UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bpJrMggOgsn4wtRabeoIEevHdxz5LhRdGkNy0fDpXT8='
WHERE
key_id = 'd77e65d7f6f2dcf99083513ae4a837f470d1a193df4c422319a72a675aeb4ac7'
AND (
token = 'bpJrMggOgsn4wtRabeoIEevHdxz5LhRdGkNy0fDpXT8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)