UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hOY9ZHGL5FpGnCW1KGTzNfAHTmSjHGpt4rbtWX39g8k='
WHERE
key_id = '58139e598f10cb988ee23c209ad0b4757564152a01a6b4be011b65ef63c1419b'
AND (
token = 'hOY9ZHGL5FpGnCW1KGTzNfAHTmSjHGpt4rbtWX39g8k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)