UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0EOzOy9Wzwz7ar8a2HffgX7PBL8lcG9eH1jJcoddNgs='
WHERE
key_id = 'd0f8ce0546aea321468994377ab0182332f0aa38e3bfc05f79851c07a153df84'
AND (
token = '0EOzOy9Wzwz7ar8a2HffgX7PBL8lcG9eH1jJcoddNgs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)