UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bUbHuYZdTEAi93MbAijyq9Sq9hwktLllm6L47XXDyHA='
WHERE
key_id = 'fdba1269d822f4e9bc6034307bb28b39fe392f538d91d2ff6816fe9f459d5332'
AND (
token = 'bUbHuYZdTEAi93MbAijyq9Sq9hwktLllm6L47XXDyHA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)