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