UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4MFAbwukx456XDJNtkPHoS/4M8yHeHZaZdUt4ZB49U0='
WHERE
key_id = 'b3f084a5b67199b1d5132288668333dbd994ba9ee04f0e28c854e40f635468c6'
AND (
token = '4MFAbwukx456XDJNtkPHoS/4M8yHeHZaZdUt4ZB49U0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)