UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mixgK27+GC6etJvVFCpFftyB/c4VDep+luQ5FsdCfIg='
WHERE
key_id = '65f042df492ff182a2ae70a9373160c8e1de7a9b12124f9a5f02dd2aa09fe473'
AND (
token = 'mixgK27+GC6etJvVFCpFftyB/c4VDep+luQ5FsdCfIg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)