UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RjPRIiQ9USYJ91xMMJ/1Z7SqAozxK3GpsKFDHlD6fOo='
WHERE
key_id = '8e2833eea5a9a1596dd7a4b3505e214cd51df37d7a8d09ea7057b258b3d7cf3a'
AND (
token = 'RjPRIiQ9USYJ91xMMJ/1Z7SqAozxK3GpsKFDHlD6fOo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)