UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CcI5b7Pd4jnSy5tktBn/qmUadPxTm6oZuWiOBXca46g='
WHERE
key_id = 'b34f29d202d972821929ba06846157ed5717fcb4ffd9c29a162a412506572f17'
AND (
token = 'CcI5b7Pd4jnSy5tktBn/qmUadPxTm6oZuWiOBXca46g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)