UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CnJ2fmnJUmwIH69n1Dptf14vjB9HMtvElA65c5zLRak='
WHERE
key_id = '38b2602bec054ba662163295b49b26df67839bd1966c7916962edee860683c6f'
AND (
token = 'CnJ2fmnJUmwIH69n1Dptf14vjB9HMtvElA65c5zLRak='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)