UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+NVbj4RBY7F1zOXsBEGCoRaSTcZ/EBEiYvrssd0TpFI='
WHERE
key_id = 'ef4215d0180f90028618891bb31f2b1507eb3567e2e8c63c0e079554636b1827'
AND (
token = '+NVbj4RBY7F1zOXsBEGCoRaSTcZ/EBEiYvrssd0TpFI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)