UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5B2YkanA6ddcT4VFHbjEvlQZCVWgeHopvvJKhSXRprk='
WHERE
key_id = '9a6a74b97d447da1199e702d10b87f95660f2c723fbea11e7ca1188123af2050'
AND (
token = '5B2YkanA6ddcT4VFHbjEvlQZCVWgeHopvvJKhSXRprk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)