UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kzTvpHZiZ922Um2p6kDVC3pmzmMnuThZbjErlf+lM2s='
WHERE
key_id = 'ba0e1bc0814357818e4fd090d381867ead14cf454efaccc9e193b1f839f93470'
AND (
token = 'kzTvpHZiZ922Um2p6kDVC3pmzmMnuThZbjErlf+lM2s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)