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