UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H16XNRnbYdhaKVT0pzfQEeuZJsgfSO5z2JXCmFTEsn4='
WHERE
key_id = '9cb7166188ad6a85068712d571a5f23f4692fd14767f17f00e8d76149e4546b9'
AND (
token = 'H16XNRnbYdhaKVT0pzfQEeuZJsgfSO5z2JXCmFTEsn4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)