UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+NV1dHkExAs9bLv5kZhn8mcqUET1bLW6wh3JY6fU4mM='
WHERE
key_id = '6985be5960052fc0137d6e5520c08b9c16de2e5e592b52182af95488a986de19'
AND (
token = '+NV1dHkExAs9bLv5kZhn8mcqUET1bLW6wh3JY6fU4mM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)