UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lgysGCDJHI9YwZOUxc880GJHozjGLJHm7XePc7XVEAQ='
WHERE
key_id = '6c63ea780e2c0be4a9c9f81f116c6a002e30e0975b63af0b5ad59c0e02a26a39'
AND (
token = 'lgysGCDJHI9YwZOUxc880GJHozjGLJHm7XePc7XVEAQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)