UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ka+AfHi1N3H6IdOpjKQ8+A6cIJ8wQfbDOHY7inEJFS4='
WHERE
key_id = '2fddc15d18e8a49346a1b705b91c9d28d42355d0df4bcee202040bfda7a4a542'
AND (
token = 'ka+AfHi1N3H6IdOpjKQ8+A6cIJ8wQfbDOHY7inEJFS4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)