UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zkcgnAkMAJrEMT9A2FEW4V37GL7BXUGJ48Ud5Y0wkLA='
WHERE
key_id = '3cdc64b771ea6d311a3809a5f4ae6f2c14314de73f934132ded1182c08a1d19a'
AND (
token = 'zkcgnAkMAJrEMT9A2FEW4V37GL7BXUGJ48Ud5Y0wkLA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)