UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7ARHhgCA/zt6E4QcenuryBfNG713vJbu5KKnax/NAgM='
WHERE
key_id = '83ad120cf09c703efdbaa65e7994f0b4313a2211a9275bc6236eae0549efb0ee'
AND (
token = '7ARHhgCA/zt6E4QcenuryBfNG713vJbu5KKnax/NAgM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)