UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zY4R5+OR8QYz1zVEfJCO0EtF4pw1KCTusAfadmY/QfQ='
WHERE
key_id = '6f1f5884f06bd20e087a643295e85905b73b126321f75600fd4fdc2b5831687b'
AND (
token = 'zY4R5+OR8QYz1zVEfJCO0EtF4pw1KCTusAfadmY/QfQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)