UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X71NwkAvLGY1dXpggLoEAQPCwKviAFjOg2EL4QH8tPg='
WHERE
key_id = '2047402f9195129856d0bcfabce8641c526f3d1d74c4c3346f40bdf3d658a4b0'
AND (
token = 'X71NwkAvLGY1dXpggLoEAQPCwKviAFjOg2EL4QH8tPg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)