UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'If71Stgp1dM/ZxphOggKQEOkT0/DQna/6jj0+7T8l/A='
WHERE
key_id = 'df1a4fe2baa30ab200f9a49e8589243ed20eccdff9bf049dae8482bc50aad4e7'
AND (
token = 'If71Stgp1dM/ZxphOggKQEOkT0/DQna/6jj0+7T8l/A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)