UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w6Eas/eY6EcvI17/ZPnqjzMkab3ZaXzi0ekT9ZonYRQ='
WHERE
key_id = '55ab24507e24062dc90043ec8eccb01a9de8c848c7b31a0c05a4d52baf6d7309'
AND (
token = 'w6Eas/eY6EcvI17/ZPnqjzMkab3ZaXzi0ekT9ZonYRQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)