UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l8pScaSJoepcwy6bFTPI8WDyKpPmTuU5i4QdQpHcpn0='
WHERE
key_id = 'e518b7244ca1a221ee75838fe9ecc86e5afd9082464f23e812faa7a4f599becc'
AND (
token = 'l8pScaSJoepcwy6bFTPI8WDyKpPmTuU5i4QdQpHcpn0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)