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