UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VEh/+E74tqXkbbIKtATzJcYY8OluSZw3dCYP5jKJoio='
WHERE
key_id = '3fe936db0041b2ce22ae4bf8790f0c87fa76c67a1858f132f85da8b4b40c346f'
AND (
token = 'VEh/+E74tqXkbbIKtATzJcYY8OluSZw3dCYP5jKJoio='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)