UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UgHP4bPnzRbDqdyI9pTmvfQ+9bGsXhgoR8gGfrWC7IY='
WHERE
key_id = '540249f9f0936224a343c9f311fdf66effbaca9d7e5adbe8f2e6588bdbaf583e'
AND (
token = 'UgHP4bPnzRbDqdyI9pTmvfQ+9bGsXhgoR8gGfrWC7IY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)