UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BsDT00IrU29YtChDOm+TVl/UG7lacn06AX7LkftG9Ag='
WHERE
key_id = 'c97aaee09f2d10389a41ea6bacf977b32e7c0ceb68ca03a9b31234857923c322'
AND (
token = 'BsDT00IrU29YtChDOm+TVl/UG7lacn06AX7LkftG9Ag='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)