UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K57oKU/z8wnvP71L23SkC63rUIzjnvunaMGVJz8GHac='
WHERE
key_id = '273a8ffc839dda4fff730b863b440844069f7d0ad7ec5bf060693e4000b67b69'
AND (
token = 'K57oKU/z8wnvP71L23SkC63rUIzjnvunaMGVJz8GHac='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)