UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rDePn81b7ZLjiIAAAPCw3bPiY295dxn1gB/zmNHGjig='
WHERE
key_id = 'e7af93e1a6454b6baa7d1adb7ef82af61e2522d7e5de894d748678ee24968003'
AND (
token = 'rDePn81b7ZLjiIAAAPCw3bPiY295dxn1gB/zmNHGjig='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)