UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G0J8gcY68EkV765AuuumJoezgznDLHbZJDB3i7DOwuE='
WHERE
key_id = '6123b95c66da1417759afc30608ddcd41d29c63b7bfb82b4bf6172cc4088419d'
AND (
token = 'G0J8gcY68EkV765AuuumJoezgznDLHbZJDB3i7DOwuE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)