UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8Ef2X3AqFqfCpZyud+x5dxcb3McAJ3fT81bSxRLRF+s='
WHERE
key_id = 'cd421cdb93b45fc4b8ffa2f39f2af0237d087c700ebd023cc0ddc600029bdbf5'
AND (
token = '8Ef2X3AqFqfCpZyud+x5dxcb3McAJ3fT81bSxRLRF+s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)