UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4tHNwYUSYG8j09KEMZJB9rJaL/pNmlnYbFJMtSH7+QA='
WHERE
key_id = 'df0fb01b609c007ebc333a813fe97cf2da16172afbe24b89e6c83c3d7d5914e4'
AND (
token = '4tHNwYUSYG8j09KEMZJB9rJaL/pNmlnYbFJMtSH7+QA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)