UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hB5somwUUt+H/h1bRo2xyMIpkQOOUGFuHq7ryTSwX58='
WHERE
key_id = 'a5f4d06027d283c8cec0b47ea57e06149541f71b7ff8a47db4ec786e8e88ea7f'
AND (
token = 'hB5somwUUt+H/h1bRo2xyMIpkQOOUGFuHq7ryTSwX58='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)